var user = {
	insert : 'insert into my_zqusers (openId,nickname,sex,country,province,city,headimgurl) values (?,?,?,?,?,?,?)',
	findByOpenId : 'select * from my_zqusers where openId=?',
	findById : 'select * from my_zqusers where id=?',
	getOrderById:'select a.id,c.photo,a.order_no,a.order_date,a.rental_date,a.time_start,a.time_end,c.name as fieldName1,'+
					'b.name as fieldName2,c.location,c.tel from my_zqpredetermineorders a '+
					'left join my_zqfootballfielddetail b on a.fieldId = b.id '+
					'left join my_zqfootballfields c on b.fieldId = c.id '+
					'where order_no = ?',
	updateUserInfo : 'update my_zqusers set name=?,invoice_title=?,invoice_company=?,mobile=? where id=?'
};

module.exports = user;